Implementation of a Real - Time Database

To appear in Information Systems real-time database system is a database system in which transactions have explicit timing constraints such as deadlines. Apart from satisfying the database consistency constraints, transaction executions must also satisfy these timing constraints. The goal of transaction and query processing in real-time databases is to maximise the number of successful transactions in the system. This paper reports on the design, development and performance evaluation of RT-Genesis, a real-time database management system resulting from modifying an existing commercial DBMS, Genesis. RT-Genesis is a relational database management system that accommodates SQL queries and transactions having time constraints. It features time-cognizant algorithms for scheduling, concurrency control and buuer management. The system has been tested and the performance of the diierent algorithms compared in isolation as well as in combination with diierent classes of SQL workloads. In addition, a two-phased approach to transaction execution has also been implemented with the goal of exploiting access invariance to improve predictability. This work demonstrates the feasibility of converting non-real-time DBMSs into real-time DBMSs for rm deadline transactions. Besides reporting on how this was achieved and on the performance of the incorporated algorithms, lessons learned from this experience are also discussed. A real-time database system is a database system in which transactions have explicit timing constraints such as deadlines. Apart from satisfying the database consistency constraints, these transactions must also satisfy these timing constraints. The goal of transaction and query processing in real-time databases is to maximise the number of successful transactions in the system. This paper reports on the development of a real-time database, RT-Genesis, resulting from modifying an existing commercial DBMS, Genesis. This necessitated priority-based transaction execution { where the priorities reeect the deadlines of transactions and are under the sole control of the DBMS, and deadline-cognizant resolution of connicts over data and other resources { where the transaction that wins in a connict is chosen based on deadline considerations. This paper reports on the design, development and performance evaluation of RT-Genesis, a real-time database management system resulting from modifying an existing commercial DBMS, Genesis. RT-Genesis is a relational database management system that accommodates SQL queries and transactions having time constraints. It features time-cognizant algorithms for scheduling, concurrency control and buuer management. The system has been tested and the performance of the diierent algorithms compared in isolation as well as in combination with diierent classes of SQL workloads. In addition, a two-phased …